package com.deyuanyun.pic.risk.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RiskAssessmentExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RiskAssessmentExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("VERSION is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("VERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Short value) {
            addCriterion("VERSION =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Short value) {
            addCriterion("VERSION <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Short value) {
            addCriterion("VERSION >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VERSION >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Short value) {
            addCriterion("VERSION <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Short value) {
            addCriterion("VERSION <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Short> values) {
            addCriterion("VERSION in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Short> values) {
            addCriterion("VERSION not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Short value1, Short value2) {
            addCriterion("VERSION between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Short value1, Short value2) {
            addCriterion("VERSION not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNull() {
            addCriterion("IS_NEWEST is null");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNotNull() {
            addCriterion("IS_NEWEST is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewestEqualTo(Short value) {
            addCriterion("IS_NEWEST =", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotEqualTo(Short value) {
            addCriterion("IS_NEWEST <>", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThan(Short value) {
            addCriterion("IS_NEWEST >", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST >=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThan(Short value) {
            addCriterion("IS_NEWEST <", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST <=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestIn(List<Short> values) {
            addCriterion("IS_NEWEST in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotIn(List<Short> values) {
            addCriterion("IS_NEWEST not in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST not between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNull() {
            addCriterion("DATA_STATED is null");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNotNull() {
            addCriterion("DATA_STATED is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatedEqualTo(String value) {
            addCriterion("DATA_STATED =", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotEqualTo(String value) {
            addCriterion("DATA_STATED <>", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThan(String value) {
            addCriterion("DATA_STATED >", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThanOrEqualTo(String value) {
            addCriterion("DATA_STATED >=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThan(String value) {
            addCriterion("DATA_STATED <", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThanOrEqualTo(String value) {
            addCriterion("DATA_STATED <=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLike(String value) {
            addCriterion("DATA_STATED like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotLike(String value) {
            addCriterion("DATA_STATED not like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedIn(List<String> values) {
            addCriterion("DATA_STATED in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotIn(List<String> values) {
            addCriterion("DATA_STATED not in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedBetween(String value1, String value2) {
            addCriterion("DATA_STATED between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotBetween(String value1, String value2) {
            addCriterion("DATA_STATED not between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNull() {
            addCriterion("PIPE_LINE_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNotNull() {
            addCriterion("PIPE_LINE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdEqualTo(String value) {
            addCriterion("PIPE_LINE_ID =", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <>", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThan(String value) {
            addCriterion("PIPE_LINE_ID >", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID >=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThan(String value) {
            addCriterion("PIPE_LINE_ID <", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLike(String value) {
            addCriterion("PIPE_LINE_ID like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotLike(String value) {
            addCriterion("PIPE_LINE_ID not like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIn(List<String> values) {
            addCriterion("PIPE_LINE_ID in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotIn(List<String> values) {
            addCriterion("PIPE_LINE_ID not in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID not between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNull() {
            addCriterion("CUSTOM_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNotNull() {
            addCriterion("CUSTOM_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER =", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <>", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThan(String value) {
            addCriterion("CUSTOM_NUMBER >", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER >=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThan(String value) {
            addCriterion("CUSTOM_NUMBER <", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLike(String value) {
            addCriterion("CUSTOM_NUMBER like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotLike(String value) {
            addCriterion("CUSTOM_NUMBER not like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER not in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER not between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME_ is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME_ =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME_ <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME_ >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME_ >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME_ <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME_ <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME_ like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME_ not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME_ in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME_ not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME_ between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME_ not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andLengthIsNull() {
            addCriterion("LENGTH is null");
            return (Criteria) this;
        }

        public Criteria andLengthIsNotNull() {
            addCriterion("LENGTH is not null");
            return (Criteria) this;
        }

        public Criteria andLengthEqualTo(BigDecimal value) {
            addCriterion("LENGTH =", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthNotEqualTo(BigDecimal value) {
            addCriterion("LENGTH <>", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthGreaterThan(BigDecimal value) {
            addCriterion("LENGTH >", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LENGTH >=", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthLessThan(BigDecimal value) {
            addCriterion("LENGTH <", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LENGTH <=", value, "length");
            return (Criteria) this;
        }

        public Criteria andLengthIn(List<BigDecimal> values) {
            addCriterion("LENGTH in", values, "length");
            return (Criteria) this;
        }

        public Criteria andLengthNotIn(List<BigDecimal> values) {
            addCriterion("LENGTH not in", values, "length");
            return (Criteria) this;
        }

        public Criteria andLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LENGTH between", value1, value2, "length");
            return (Criteria) this;
        }

        public Criteria andLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LENGTH not between", value1, value2, "length");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionIsNull() {
            addCriterion("FROM_LOCATION_DESCRIPTION is null");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionIsNotNull() {
            addCriterion("FROM_LOCATION_DESCRIPTION is not null");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionEqualTo(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION =", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionNotEqualTo(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION <>", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionGreaterThan(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION >", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION >=", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionLessThan(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION <", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionLessThanOrEqualTo(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION <=", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionLike(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION like", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionNotLike(String value) {
            addCriterion("FROM_LOCATION_DESCRIPTION not like", value, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionIn(List<String> values) {
            addCriterion("FROM_LOCATION_DESCRIPTION in", values, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionNotIn(List<String> values) {
            addCriterion("FROM_LOCATION_DESCRIPTION not in", values, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionBetween(String value1, String value2) {
            addCriterion("FROM_LOCATION_DESCRIPTION between", value1, value2, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andFromLocationDescriptionNotBetween(String value1, String value2) {
            addCriterion("FROM_LOCATION_DESCRIPTION not between", value1, value2, "fromLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionIsNull() {
            addCriterion("TO_LOCATION_DESCRIPTION is null");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionIsNotNull() {
            addCriterion("TO_LOCATION_DESCRIPTION is not null");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionEqualTo(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION =", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionNotEqualTo(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION <>", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionGreaterThan(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION >", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION >=", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionLessThan(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION <", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionLessThanOrEqualTo(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION <=", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionLike(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION like", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionNotLike(String value) {
            addCriterion("TO_LOCATION_DESCRIPTION not like", value, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionIn(List<String> values) {
            addCriterion("TO_LOCATION_DESCRIPTION in", values, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionNotIn(List<String> values) {
            addCriterion("TO_LOCATION_DESCRIPTION not in", values, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionBetween(String value1, String value2) {
            addCriterion("TO_LOCATION_DESCRIPTION between", value1, value2, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andToLocationDescriptionNotBetween(String value1, String value2) {
            addCriterion("TO_LOCATION_DESCRIPTION not between", value1, value2, "toLocationDescription");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingIsNull() {
            addCriterion("RISKA_CCRODING is null");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingIsNotNull() {
            addCriterion("RISKA_CCRODING is not null");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingEqualTo(String value) {
            addCriterion("RISKA_CCRODING =", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingNotEqualTo(String value) {
            addCriterion("RISKA_CCRODING <>", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingGreaterThan(String value) {
            addCriterion("RISKA_CCRODING >", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingGreaterThanOrEqualTo(String value) {
            addCriterion("RISKA_CCRODING >=", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingLessThan(String value) {
            addCriterion("RISKA_CCRODING <", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingLessThanOrEqualTo(String value) {
            addCriterion("RISKA_CCRODING <=", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingLike(String value) {
            addCriterion("RISKA_CCRODING like", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingNotLike(String value) {
            addCriterion("RISKA_CCRODING not like", value, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingIn(List<String> values) {
            addCriterion("RISKA_CCRODING in", values, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingNotIn(List<String> values) {
            addCriterion("RISKA_CCRODING not in", values, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingBetween(String value1, String value2) {
            addCriterion("RISKA_CCRODING between", value1, value2, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andRiskaCcrodingNotBetween(String value1, String value2) {
            addCriterion("RISKA_CCRODING not between", value1, value2, "riskaCcroding");
            return (Criteria) this;
        }

        public Criteria andAreaLevelIsNull() {
            addCriterion("AREA_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andAreaLevelIsNotNull() {
            addCriterion("AREA_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andAreaLevelEqualTo(String value) {
            addCriterion("AREA_LEVEL =", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelNotEqualTo(String value) {
            addCriterion("AREA_LEVEL <>", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelGreaterThan(String value) {
            addCriterion("AREA_LEVEL >", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelGreaterThanOrEqualTo(String value) {
            addCriterion("AREA_LEVEL >=", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelLessThan(String value) {
            addCriterion("AREA_LEVEL <", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelLessThanOrEqualTo(String value) {
            addCriterion("AREA_LEVEL <=", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelLike(String value) {
            addCriterion("AREA_LEVEL like", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelNotLike(String value) {
            addCriterion("AREA_LEVEL not like", value, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelIn(List<String> values) {
            addCriterion("AREA_LEVEL in", values, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelNotIn(List<String> values) {
            addCriterion("AREA_LEVEL not in", values, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelBetween(String value1, String value2) {
            addCriterion("AREA_LEVEL between", value1, value2, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andAreaLevelNotBetween(String value1, String value2) {
            addCriterion("AREA_LEVEL not between", value1, value2, "areaLevel");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodIsNull() {
            addCriterion("EVALUATE_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodIsNotNull() {
            addCriterion("EVALUATE_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodEqualTo(String value) {
            addCriterion("EVALUATE_METHOD =", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodNotEqualTo(String value) {
            addCriterion("EVALUATE_METHOD <>", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodGreaterThan(String value) {
            addCriterion("EVALUATE_METHOD >", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodGreaterThanOrEqualTo(String value) {
            addCriterion("EVALUATE_METHOD >=", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodLessThan(String value) {
            addCriterion("EVALUATE_METHOD <", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodLessThanOrEqualTo(String value) {
            addCriterion("EVALUATE_METHOD <=", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodLike(String value) {
            addCriterion("EVALUATE_METHOD like", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodNotLike(String value) {
            addCriterion("EVALUATE_METHOD not like", value, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodIn(List<String> values) {
            addCriterion("EVALUATE_METHOD in", values, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodNotIn(List<String> values) {
            addCriterion("EVALUATE_METHOD not in", values, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodBetween(String value1, String value2) {
            addCriterion("EVALUATE_METHOD between", value1, value2, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andEvaluateMethodNotBetween(String value1, String value2) {
            addCriterion("EVALUATE_METHOD not between", value1, value2, "evaluateMethod");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreIsNull() {
            addCriterion("RELATIVE_RISK_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreIsNotNull() {
            addCriterion("RELATIVE_RISK_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreEqualTo(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE =", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreNotEqualTo(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE <>", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreGreaterThan(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE >", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE >=", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreLessThan(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE <", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RELATIVE_RISK_SCORE <=", value, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreIn(List<BigDecimal> values) {
            addCriterion("RELATIVE_RISK_SCORE in", values, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreNotIn(List<BigDecimal> values) {
            addCriterion("RELATIVE_RISK_SCORE not in", values, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RELATIVE_RISK_SCORE between", value1, value2, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andRelativeRiskScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RELATIVE_RISK_SCORE not between", value1, value2, "relativeRiskScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreIsNull() {
            addCriterion("DAMAGE_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andDamageScoreIsNotNull() {
            addCriterion("DAMAGE_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andDamageScoreEqualTo(BigDecimal value) {
            addCriterion("DAMAGE_SCORE =", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreNotEqualTo(BigDecimal value) {
            addCriterion("DAMAGE_SCORE <>", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreGreaterThan(BigDecimal value) {
            addCriterion("DAMAGE_SCORE >", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DAMAGE_SCORE >=", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreLessThan(BigDecimal value) {
            addCriterion("DAMAGE_SCORE <", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DAMAGE_SCORE <=", value, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreIn(List<BigDecimal> values) {
            addCriterion("DAMAGE_SCORE in", values, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreNotIn(List<BigDecimal> values) {
            addCriterion("DAMAGE_SCORE not in", values, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DAMAGE_SCORE between", value1, value2, "damageScore");
            return (Criteria) this;
        }

        public Criteria andDamageScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DAMAGE_SCORE not between", value1, value2, "damageScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreIsNull() {
            addCriterion("CORROSION_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreIsNotNull() {
            addCriterion("CORROSION_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreEqualTo(BigDecimal value) {
            addCriterion("CORROSION_SCORE =", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreNotEqualTo(BigDecimal value) {
            addCriterion("CORROSION_SCORE <>", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreGreaterThan(BigDecimal value) {
            addCriterion("CORROSION_SCORE >", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CORROSION_SCORE >=", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreLessThan(BigDecimal value) {
            addCriterion("CORROSION_SCORE <", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CORROSION_SCORE <=", value, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreIn(List<BigDecimal> values) {
            addCriterion("CORROSION_SCORE in", values, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreNotIn(List<BigDecimal> values) {
            addCriterion("CORROSION_SCORE not in", values, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CORROSION_SCORE between", value1, value2, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andCorrosionScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CORROSION_SCORE not between", value1, value2, "corrosionScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreIsNull() {
            addCriterion("DES_CONSTR_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreIsNotNull() {
            addCriterion("DES_CONSTR_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreEqualTo(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE =", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreNotEqualTo(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE <>", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreGreaterThan(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE >", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE >=", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreLessThan(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE <", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DES_CONSTR_SCORE <=", value, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreIn(List<BigDecimal> values) {
            addCriterion("DES_CONSTR_SCORE in", values, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreNotIn(List<BigDecimal> values) {
            addCriterion("DES_CONSTR_SCORE not in", values, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DES_CONSTR_SCORE between", value1, value2, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andDesConstrScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DES_CONSTR_SCORE not between", value1, value2, "desConstrScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreIsNull() {
            addCriterion("GEOHAZARD_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreIsNotNull() {
            addCriterion("GEOHAZARD_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreEqualTo(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE =", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreNotEqualTo(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE <>", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreGreaterThan(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE >", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE >=", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreLessThan(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE <", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GEOHAZARD_SCORE <=", value, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreIn(List<BigDecimal> values) {
            addCriterion("GEOHAZARD_SCORE in", values, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreNotIn(List<BigDecimal> values) {
            addCriterion("GEOHAZARD_SCORE not in", values, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GEOHAZARD_SCORE between", value1, value2, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andGeohazardScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GEOHAZARD_SCORE not between", value1, value2, "geohazardScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreIsNull() {
            addCriterion("OPERATION_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andOperationScoreIsNotNull() {
            addCriterion("OPERATION_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andOperationScoreEqualTo(BigDecimal value) {
            addCriterion("OPERATION_SCORE =", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreNotEqualTo(BigDecimal value) {
            addCriterion("OPERATION_SCORE <>", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreGreaterThan(BigDecimal value) {
            addCriterion("OPERATION_SCORE >", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("OPERATION_SCORE >=", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreLessThan(BigDecimal value) {
            addCriterion("OPERATION_SCORE <", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreLessThanOrEqualTo(BigDecimal value) {
            addCriterion("OPERATION_SCORE <=", value, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreIn(List<BigDecimal> values) {
            addCriterion("OPERATION_SCORE in", values, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreNotIn(List<BigDecimal> values) {
            addCriterion("OPERATION_SCORE not in", values, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OPERATION_SCORE between", value1, value2, "operationScore");
            return (Criteria) this;
        }

        public Criteria andOperationScoreNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("OPERATION_SCORE not between", value1, value2, "operationScore");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientIsNull() {
            addCriterion("LEAD_COEFFICIENT is null");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientIsNotNull() {
            addCriterion("LEAD_COEFFICIENT is not null");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientEqualTo(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT =", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientNotEqualTo(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT <>", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientGreaterThan(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT >", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT >=", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientLessThan(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT <", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LEAD_COEFFICIENT <=", value, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientIn(List<BigDecimal> values) {
            addCriterion("LEAD_COEFFICIENT in", values, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientNotIn(List<BigDecimal> values) {
            addCriterion("LEAD_COEFFICIENT not in", values, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LEAD_COEFFICIENT between", value1, value2, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andLeadCoefficientNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LEAD_COEFFICIENT not between", value1, value2, "leadCoefficient");
            return (Criteria) this;
        }

        public Criteria andRiskGradeIsNull() {
            addCriterion("RISK_GRADE is null");
            return (Criteria) this;
        }

        public Criteria andRiskGradeIsNotNull() {
            addCriterion("RISK_GRADE is not null");
            return (Criteria) this;
        }

        public Criteria andRiskGradeEqualTo(String value) {
            addCriterion("RISK_GRADE =", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeNotEqualTo(String value) {
            addCriterion("RISK_GRADE <>", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeGreaterThan(String value) {
            addCriterion("RISK_GRADE >", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeGreaterThanOrEqualTo(String value) {
            addCriterion("RISK_GRADE >=", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeLessThan(String value) {
            addCriterion("RISK_GRADE <", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeLessThanOrEqualTo(String value) {
            addCriterion("RISK_GRADE <=", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeLike(String value) {
            addCriterion("RISK_GRADE like", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeNotLike(String value) {
            addCriterion("RISK_GRADE not like", value, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeIn(List<String> values) {
            addCriterion("RISK_GRADE in", values, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeNotIn(List<String> values) {
            addCriterion("RISK_GRADE not in", values, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeBetween(String value1, String value2) {
            addCriterion("RISK_GRADE between", value1, value2, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andRiskGradeNotBetween(String value1, String value2) {
            addCriterion("RISK_GRADE not between", value1, value2, "riskGrade");
            return (Criteria) this;
        }

        public Criteria andMainThreatsIsNull() {
            addCriterion("MAIN_THREATS is null");
            return (Criteria) this;
        }

        public Criteria andMainThreatsIsNotNull() {
            addCriterion("MAIN_THREATS is not null");
            return (Criteria) this;
        }

        public Criteria andMainThreatsEqualTo(String value) {
            addCriterion("MAIN_THREATS =", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsNotEqualTo(String value) {
            addCriterion("MAIN_THREATS <>", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsGreaterThan(String value) {
            addCriterion("MAIN_THREATS >", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsGreaterThanOrEqualTo(String value) {
            addCriterion("MAIN_THREATS >=", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsLessThan(String value) {
            addCriterion("MAIN_THREATS <", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsLessThanOrEqualTo(String value) {
            addCriterion("MAIN_THREATS <=", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsLike(String value) {
            addCriterion("MAIN_THREATS like", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsNotLike(String value) {
            addCriterion("MAIN_THREATS not like", value, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsIn(List<String> values) {
            addCriterion("MAIN_THREATS in", values, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsNotIn(List<String> values) {
            addCriterion("MAIN_THREATS not in", values, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsBetween(String value1, String value2) {
            addCriterion("MAIN_THREATS between", value1, value2, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andMainThreatsNotBetween(String value1, String value2) {
            addCriterion("MAIN_THREATS not between", value1, value2, "mainThreats");
            return (Criteria) this;
        }

        public Criteria andRiskProposalIsNull() {
            addCriterion("RISK_PROPOSAL is null");
            return (Criteria) this;
        }

        public Criteria andRiskProposalIsNotNull() {
            addCriterion("RISK_PROPOSAL is not null");
            return (Criteria) this;
        }

        public Criteria andRiskProposalEqualTo(String value) {
            addCriterion("RISK_PROPOSAL =", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalNotEqualTo(String value) {
            addCriterion("RISK_PROPOSAL <>", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalGreaterThan(String value) {
            addCriterion("RISK_PROPOSAL >", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalGreaterThanOrEqualTo(String value) {
            addCriterion("RISK_PROPOSAL >=", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalLessThan(String value) {
            addCriterion("RISK_PROPOSAL <", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalLessThanOrEqualTo(String value) {
            addCriterion("RISK_PROPOSAL <=", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalLike(String value) {
            addCriterion("RISK_PROPOSAL like", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalNotLike(String value) {
            addCriterion("RISK_PROPOSAL not like", value, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalIn(List<String> values) {
            addCriterion("RISK_PROPOSAL in", values, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalNotIn(List<String> values) {
            addCriterion("RISK_PROPOSAL not in", values, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalBetween(String value1, String value2) {
            addCriterion("RISK_PROPOSAL between", value1, value2, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andRiskProposalNotBetween(String value1, String value2) {
            addCriterion("RISK_PROPOSAL not between", value1, value2, "riskProposal");
            return (Criteria) this;
        }

        public Criteria andMeasureIsNull() {
            addCriterion("MEASURE is null");
            return (Criteria) this;
        }

        public Criteria andMeasureIsNotNull() {
            addCriterion("MEASURE is not null");
            return (Criteria) this;
        }

        public Criteria andMeasureEqualTo(String value) {
            addCriterion("MEASURE =", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureNotEqualTo(String value) {
            addCriterion("MEASURE <>", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureGreaterThan(String value) {
            addCriterion("MEASURE >", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureGreaterThanOrEqualTo(String value) {
            addCriterion("MEASURE >=", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureLessThan(String value) {
            addCriterion("MEASURE <", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureLessThanOrEqualTo(String value) {
            addCriterion("MEASURE <=", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureLike(String value) {
            addCriterion("MEASURE like", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureNotLike(String value) {
            addCriterion("MEASURE not like", value, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureIn(List<String> values) {
            addCriterion("MEASURE in", values, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureNotIn(List<String> values) {
            addCriterion("MEASURE not in", values, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureBetween(String value1, String value2) {
            addCriterion("MEASURE between", value1, value2, "measure");
            return (Criteria) this;
        }

        public Criteria andMeasureNotBetween(String value1, String value2) {
            addCriterion("MEASURE not between", value1, value2, "measure");
            return (Criteria) this;
        }

        public Criteria andIsControllableIsNull() {
            addCriterion("IS_CONTROLLABLE is null");
            return (Criteria) this;
        }

        public Criteria andIsControllableIsNotNull() {
            addCriterion("IS_CONTROLLABLE is not null");
            return (Criteria) this;
        }

        public Criteria andIsControllableEqualTo(Short value) {
            addCriterion("IS_CONTROLLABLE =", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableNotEqualTo(Short value) {
            addCriterion("IS_CONTROLLABLE <>", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableGreaterThan(Short value) {
            addCriterion("IS_CONTROLLABLE >", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_CONTROLLABLE >=", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableLessThan(Short value) {
            addCriterion("IS_CONTROLLABLE <", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableLessThanOrEqualTo(Short value) {
            addCriterion("IS_CONTROLLABLE <=", value, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableIn(List<Short> values) {
            addCriterion("IS_CONTROLLABLE in", values, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableNotIn(List<Short> values) {
            addCriterion("IS_CONTROLLABLE not in", values, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableBetween(Short value1, Short value2) {
            addCriterion("IS_CONTROLLABLE between", value1, value2, "isControllable");
            return (Criteria) this;
        }

        public Criteria andIsControllableNotBetween(Short value1, Short value2) {
            addCriterion("IS_CONTROLLABLE not between", value1, value2, "isControllable");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresIsNull() {
            addCriterion("CONTROL_MEASURES is null");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresIsNotNull() {
            addCriterion("CONTROL_MEASURES is not null");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresEqualTo(String value) {
            addCriterion("CONTROL_MEASURES =", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresNotEqualTo(String value) {
            addCriterion("CONTROL_MEASURES <>", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresGreaterThan(String value) {
            addCriterion("CONTROL_MEASURES >", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresGreaterThanOrEqualTo(String value) {
            addCriterion("CONTROL_MEASURES >=", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresLessThan(String value) {
            addCriterion("CONTROL_MEASURES <", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresLessThanOrEqualTo(String value) {
            addCriterion("CONTROL_MEASURES <=", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresLike(String value) {
            addCriterion("CONTROL_MEASURES like", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresNotLike(String value) {
            addCriterion("CONTROL_MEASURES not like", value, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresIn(List<String> values) {
            addCriterion("CONTROL_MEASURES in", values, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresNotIn(List<String> values) {
            addCriterion("CONTROL_MEASURES not in", values, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresBetween(String value1, String value2) {
            addCriterion("CONTROL_MEASURES between", value1, value2, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andControlMeasuresNotBetween(String value1, String value2) {
            addCriterion("CONTROL_MEASURES not between", value1, value2, "controlMeasures");
            return (Criteria) this;
        }

        public Criteria andImplementDateIsNull() {
            addCriterion("IMPLEMENT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andImplementDateIsNotNull() {
            addCriterion("IMPLEMENT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andImplementDateEqualTo(Date value) {
            addCriterion("IMPLEMENT_DATE =", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateNotEqualTo(Date value) {
            addCriterion("IMPLEMENT_DATE <>", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateGreaterThan(Date value) {
            addCriterion("IMPLEMENT_DATE >", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateGreaterThanOrEqualTo(Date value) {
            addCriterion("IMPLEMENT_DATE >=", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateLessThan(Date value) {
            addCriterion("IMPLEMENT_DATE <", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateLessThanOrEqualTo(Date value) {
            addCriterion("IMPLEMENT_DATE <=", value, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateIn(List<Date> values) {
            addCriterion("IMPLEMENT_DATE in", values, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateNotIn(List<Date> values) {
            addCriterion("IMPLEMENT_DATE not in", values, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateBetween(Date value1, Date value2) {
            addCriterion("IMPLEMENT_DATE between", value1, value2, "implementDate");
            return (Criteria) this;
        }

        public Criteria andImplementDateNotBetween(Date value1, Date value2) {
            addCriterion("IMPLEMENT_DATE not between", value1, value2, "implementDate");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeIsNull() {
            addCriterion("EVALUATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeIsNotNull() {
            addCriterion("EVALUATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeEqualTo(Date value) {
            addCriterion("EVALUATE_TIME =", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeNotEqualTo(Date value) {
            addCriterion("EVALUATE_TIME <>", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeGreaterThan(Date value) {
            addCriterion("EVALUATE_TIME >", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("EVALUATE_TIME >=", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeLessThan(Date value) {
            addCriterion("EVALUATE_TIME <", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeLessThanOrEqualTo(Date value) {
            addCriterion("EVALUATE_TIME <=", value, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeIn(List<Date> values) {
            addCriterion("EVALUATE_TIME in", values, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeNotIn(List<Date> values) {
            addCriterion("EVALUATE_TIME not in", values, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeBetween(Date value1, Date value2) {
            addCriterion("EVALUATE_TIME between", value1, value2, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateTimeNotBetween(Date value1, Date value2) {
            addCriterion("EVALUATE_TIME not between", value1, value2, "evaluateTime");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyIsNull() {
            addCriterion("EVALUATE_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyIsNotNull() {
            addCriterion("EVALUATE_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyEqualTo(String value) {
            addCriterion("EVALUATE_COMPANY =", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyNotEqualTo(String value) {
            addCriterion("EVALUATE_COMPANY <>", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyGreaterThan(String value) {
            addCriterion("EVALUATE_COMPANY >", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("EVALUATE_COMPANY >=", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyLessThan(String value) {
            addCriterion("EVALUATE_COMPANY <", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyLessThanOrEqualTo(String value) {
            addCriterion("EVALUATE_COMPANY <=", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyLike(String value) {
            addCriterion("EVALUATE_COMPANY like", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyNotLike(String value) {
            addCriterion("EVALUATE_COMPANY not like", value, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyIn(List<String> values) {
            addCriterion("EVALUATE_COMPANY in", values, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyNotIn(List<String> values) {
            addCriterion("EVALUATE_COMPANY not in", values, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyBetween(String value1, String value2) {
            addCriterion("EVALUATE_COMPANY between", value1, value2, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andEvaluateCompanyNotBetween(String value1, String value2) {
            addCriterion("EVALUATE_COMPANY not between", value1, value2, "evaluateCompany");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeIsNull() {
            addCriterion("NEXT_EVALUATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeIsNotNull() {
            addCriterion("NEXT_EVALUATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeEqualTo(Date value) {
            addCriterion("NEXT_EVALUATE_TIME =", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeNotEqualTo(Date value) {
            addCriterion("NEXT_EVALUATE_TIME <>", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeGreaterThan(Date value) {
            addCriterion("NEXT_EVALUATE_TIME >", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("NEXT_EVALUATE_TIME >=", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeLessThan(Date value) {
            addCriterion("NEXT_EVALUATE_TIME <", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeLessThanOrEqualTo(Date value) {
            addCriterion("NEXT_EVALUATE_TIME <=", value, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeIn(List<Date> values) {
            addCriterion("NEXT_EVALUATE_TIME in", values, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeNotIn(List<Date> values) {
            addCriterion("NEXT_EVALUATE_TIME not in", values, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeBetween(Date value1, Date value2) {
            addCriterion("NEXT_EVALUATE_TIME between", value1, value2, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andNextEvaluateTimeNotBetween(Date value1, Date value2) {
            addCriterion("NEXT_EVALUATE_TIME not between", value1, value2, "nextEvaluateTime");
            return (Criteria) this;
        }

        public Criteria andRecrderIsNull() {
            addCriterion("RECRDER is null");
            return (Criteria) this;
        }

        public Criteria andRecrderIsNotNull() {
            addCriterion("RECRDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecrderEqualTo(String value) {
            addCriterion("RECRDER =", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotEqualTo(String value) {
            addCriterion("RECRDER <>", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderGreaterThan(String value) {
            addCriterion("RECRDER >", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderGreaterThanOrEqualTo(String value) {
            addCriterion("RECRDER >=", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLessThan(String value) {
            addCriterion("RECRDER <", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLessThanOrEqualTo(String value) {
            addCriterion("RECRDER <=", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLike(String value) {
            addCriterion("RECRDER like", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotLike(String value) {
            addCriterion("RECRDER not like", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderIn(List<String> values) {
            addCriterion("RECRDER in", values, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotIn(List<String> values) {
            addCriterion("RECRDER not in", values, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderBetween(String value1, String value2) {
            addCriterion("RECRDER between", value1, value2, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotBetween(String value1, String value2) {
            addCriterion("RECRDER not between", value1, value2, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("RECORD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("RECORD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("RECORD_TIME =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("RECORD_TIME <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("RECORD_TIME >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("RECORD_TIME <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("RECORD_TIME in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("RECORD_TIME not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andFromMileageIsNull() {
            addCriterion("FROM_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andFromMileageIsNotNull() {
            addCriterion("FROM_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andFromMileageEqualTo(BigDecimal value) {
            addCriterion("FROM_MILEAGE =", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageNotEqualTo(BigDecimal value) {
            addCriterion("FROM_MILEAGE <>", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageGreaterThan(BigDecimal value) {
            addCriterion("FROM_MILEAGE >", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FROM_MILEAGE >=", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageLessThan(BigDecimal value) {
            addCriterion("FROM_MILEAGE <", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FROM_MILEAGE <=", value, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageIn(List<BigDecimal> values) {
            addCriterion("FROM_MILEAGE in", values, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageNotIn(List<BigDecimal> values) {
            addCriterion("FROM_MILEAGE not in", values, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FROM_MILEAGE between", value1, value2, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromMileageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FROM_MILEAGE not between", value1, value2, "fromMileage");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdIsNull() {
            addCriterion("FROM_REFERENCE_ID is null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdIsNotNull() {
            addCriterion("FROM_REFERENCE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdEqualTo(String value) {
            addCriterion("FROM_REFERENCE_ID =", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdNotEqualTo(String value) {
            addCriterion("FROM_REFERENCE_ID <>", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdGreaterThan(String value) {
            addCriterion("FROM_REFERENCE_ID >", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdGreaterThanOrEqualTo(String value) {
            addCriterion("FROM_REFERENCE_ID >=", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdLessThan(String value) {
            addCriterion("FROM_REFERENCE_ID <", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdLessThanOrEqualTo(String value) {
            addCriterion("FROM_REFERENCE_ID <=", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdLike(String value) {
            addCriterion("FROM_REFERENCE_ID like", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdNotLike(String value) {
            addCriterion("FROM_REFERENCE_ID not like", value, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdIn(List<String> values) {
            addCriterion("FROM_REFERENCE_ID in", values, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdNotIn(List<String> values) {
            addCriterion("FROM_REFERENCE_ID not in", values, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdBetween(String value1, String value2) {
            addCriterion("FROM_REFERENCE_ID between", value1, value2, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIdNotBetween(String value1, String value2) {
            addCriterion("FROM_REFERENCE_ID not between", value1, value2, "fromReferenceId");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIsNull() {
            addCriterion("FROM_REFERENCE is null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIsNotNull() {
            addCriterion("FROM_REFERENCE is not null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceEqualTo(String value) {
            addCriterion("FROM_REFERENCE =", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceNotEqualTo(String value) {
            addCriterion("FROM_REFERENCE <>", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceGreaterThan(String value) {
            addCriterion("FROM_REFERENCE >", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceGreaterThanOrEqualTo(String value) {
            addCriterion("FROM_REFERENCE >=", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceLessThan(String value) {
            addCriterion("FROM_REFERENCE <", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceLessThanOrEqualTo(String value) {
            addCriterion("FROM_REFERENCE <=", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceLike(String value) {
            addCriterion("FROM_REFERENCE like", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceNotLike(String value) {
            addCriterion("FROM_REFERENCE not like", value, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceIn(List<String> values) {
            addCriterion("FROM_REFERENCE in", values, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceNotIn(List<String> values) {
            addCriterion("FROM_REFERENCE not in", values, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceBetween(String value1, String value2) {
            addCriterion("FROM_REFERENCE between", value1, value2, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceNotBetween(String value1, String value2) {
            addCriterion("FROM_REFERENCE not between", value1, value2, "fromReference");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceIsNull() {
            addCriterion("FROM_REFERENCE_DISTANCE is null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceIsNotNull() {
            addCriterion("FROM_REFERENCE_DISTANCE is not null");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceEqualTo(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE =", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceNotEqualTo(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE <>", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceGreaterThan(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE >", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE >=", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceLessThan(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE <", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FROM_REFERENCE_DISTANCE <=", value, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceIn(List<BigDecimal> values) {
            addCriterion("FROM_REFERENCE_DISTANCE in", values, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceNotIn(List<BigDecimal> values) {
            addCriterion("FROM_REFERENCE_DISTANCE not in", values, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FROM_REFERENCE_DISTANCE between", value1, value2, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andFromReferenceDistanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FROM_REFERENCE_DISTANCE not between", value1, value2, "fromReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToMileageIsNull() {
            addCriterion("TO_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andToMileageIsNotNull() {
            addCriterion("TO_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andToMileageEqualTo(BigDecimal value) {
            addCriterion("TO_MILEAGE =", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageNotEqualTo(BigDecimal value) {
            addCriterion("TO_MILEAGE <>", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageGreaterThan(BigDecimal value) {
            addCriterion("TO_MILEAGE >", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TO_MILEAGE >=", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageLessThan(BigDecimal value) {
            addCriterion("TO_MILEAGE <", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TO_MILEAGE <=", value, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageIn(List<BigDecimal> values) {
            addCriterion("TO_MILEAGE in", values, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageNotIn(List<BigDecimal> values) {
            addCriterion("TO_MILEAGE not in", values, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TO_MILEAGE between", value1, value2, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToMileageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TO_MILEAGE not between", value1, value2, "toMileage");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdIsNull() {
            addCriterion("TO_REFERENCE_ID is null");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdIsNotNull() {
            addCriterion("TO_REFERENCE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdEqualTo(String value) {
            addCriterion("TO_REFERENCE_ID =", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdNotEqualTo(String value) {
            addCriterion("TO_REFERENCE_ID <>", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdGreaterThan(String value) {
            addCriterion("TO_REFERENCE_ID >", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdGreaterThanOrEqualTo(String value) {
            addCriterion("TO_REFERENCE_ID >=", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdLessThan(String value) {
            addCriterion("TO_REFERENCE_ID <", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdLessThanOrEqualTo(String value) {
            addCriterion("TO_REFERENCE_ID <=", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdLike(String value) {
            addCriterion("TO_REFERENCE_ID like", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdNotLike(String value) {
            addCriterion("TO_REFERENCE_ID not like", value, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdIn(List<String> values) {
            addCriterion("TO_REFERENCE_ID in", values, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdNotIn(List<String> values) {
            addCriterion("TO_REFERENCE_ID not in", values, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdBetween(String value1, String value2) {
            addCriterion("TO_REFERENCE_ID between", value1, value2, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIdNotBetween(String value1, String value2) {
            addCriterion("TO_REFERENCE_ID not between", value1, value2, "toReferenceId");
            return (Criteria) this;
        }

        public Criteria andToReferenceIsNull() {
            addCriterion("TO_REFERENCE is null");
            return (Criteria) this;
        }

        public Criteria andToReferenceIsNotNull() {
            addCriterion("TO_REFERENCE is not null");
            return (Criteria) this;
        }

        public Criteria andToReferenceEqualTo(String value) {
            addCriterion("TO_REFERENCE =", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceNotEqualTo(String value) {
            addCriterion("TO_REFERENCE <>", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceGreaterThan(String value) {
            addCriterion("TO_REFERENCE >", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceGreaterThanOrEqualTo(String value) {
            addCriterion("TO_REFERENCE >=", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceLessThan(String value) {
            addCriterion("TO_REFERENCE <", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceLessThanOrEqualTo(String value) {
            addCriterion("TO_REFERENCE <=", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceLike(String value) {
            addCriterion("TO_REFERENCE like", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceNotLike(String value) {
            addCriterion("TO_REFERENCE not like", value, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceIn(List<String> values) {
            addCriterion("TO_REFERENCE in", values, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceNotIn(List<String> values) {
            addCriterion("TO_REFERENCE not in", values, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceBetween(String value1, String value2) {
            addCriterion("TO_REFERENCE between", value1, value2, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceNotBetween(String value1, String value2) {
            addCriterion("TO_REFERENCE not between", value1, value2, "toReference");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceIsNull() {
            addCriterion("TO_REFERENCE_DISTANCE is null");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceIsNotNull() {
            addCriterion("TO_REFERENCE_DISTANCE is not null");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceEqualTo(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE =", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceNotEqualTo(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE <>", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceGreaterThan(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE >", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE >=", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceLessThan(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE <", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TO_REFERENCE_DISTANCE <=", value, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceIn(List<BigDecimal> values) {
            addCriterion("TO_REFERENCE_DISTANCE in", values, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceNotIn(List<BigDecimal> values) {
            addCriterion("TO_REFERENCE_DISTANCE not in", values, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TO_REFERENCE_DISTANCE between", value1, value2, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andToReferenceDistanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TO_REFERENCE_DISTANCE not between", value1, value2, "toReferenceDistance");
            return (Criteria) this;
        }

        public Criteria andGisIdIsNull() {
            addCriterion("GIS_ID is null");
            return (Criteria) this;
        }

        public Criteria andGisIdIsNotNull() {
            addCriterion("GIS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andGisIdEqualTo(String value) {
            addCriterion("GIS_ID =", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotEqualTo(String value) {
            addCriterion("GIS_ID <>", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdGreaterThan(String value) {
            addCriterion("GIS_ID >", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdGreaterThanOrEqualTo(String value) {
            addCriterion("GIS_ID >=", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLessThan(String value) {
            addCriterion("GIS_ID <", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLessThanOrEqualTo(String value) {
            addCriterion("GIS_ID <=", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdLike(String value) {
            addCriterion("GIS_ID like", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotLike(String value) {
            addCriterion("GIS_ID not like", value, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdIn(List<String> values) {
            addCriterion("GIS_ID in", values, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotIn(List<String> values) {
            addCriterion("GIS_ID not in", values, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdBetween(String value1, String value2) {
            addCriterion("GIS_ID between", value1, value2, "gisId");
            return (Criteria) this;
        }

        public Criteria andGisIdNotBetween(String value1, String value2) {
            addCriterion("GIS_ID not between", value1, value2, "gisId");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNull() {
            addCriterion("ORG_BIZ_PATH is null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNotNull() {
            addCriterion("ORG_BIZ_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH =", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <>", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThan(String value) {
            addCriterion("ORG_BIZ_PATH >", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH >=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThan(String value) {
            addCriterion("ORG_BIZ_PATH <", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLike(String value) {
            addCriterion("ORG_BIZ_PATH like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotLike(String value) {
            addCriterion("ORG_BIZ_PATH not like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH not in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH not between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}